HW#4 --- last modified January 01 1970 00:00:00..

Solution set.

Due date: Apr 19

Files to be submitted:
  family.zip
  family.sql
  web.xml

Purpose: To gain experience with HttpSession, JSP, JavaBeans, and JDBC.

Specification:

The goal of this assignment is to create a web-site for maintaining family histories. This homework is somewhat more open ended than the previous homeworks and to encourage creativety up to two bonus points will be awarded to people who turn in project which are exceptionally noteworthy. As a minimum your site must satisfy the following design goals:

1. You should have a main page for your site. This page should say what the site is and make as clear as possible all the different things that can be done on the site.
2. Pages in your site should be either straight HTML pages (faster) or JSP pages. You must have at least one page that make non-trivial use of JSP and a Java Bean. All of your pages, together with any Java Beans you use should be submitted in the file family.zip.
3. You should use HttpSession to maintain state during at least one form interaction.
4. You should verify at least one form using Javascript.
5. Your site should maintain in an Oracle database family members' names, date of birth, date of death, marital relations, parents, spouses, and children. It should also maintain for each person a brief description of their life. You should store all the SQL CREATE TABLE commands needed to create your database in the file family.sql. The grader will use this file in testing your homework.
6. How your site connects to DB should be done using the web.xml file you submit.
7. Your site should allow the addition of new people entries to the database and provide a means for people to rate the validity of an entry. The latter is to discourage random people on the web from inserting bogus entries.
8. Your site should provide at least two modes to look up any data that has already been stored. For example, one mode might be to look a person by the name and approximate time range. Another might be by the display of some kind of family tree. (The latter might be hard to implement so you might try to think of something easier.)

Point Breakdown